Tabela PaymentTransaction

Definicja tabeli PaymentTransaction

Name

PaymentTransaction

Code

PaymentTransaction

Comment

Transakcje platnosci


Lista kolumn tabeli PaymentTransaction

Name

Code

PaymentTransactionID

PaymentTransactionID

PaymentServiceID

PaymentServiceID

Service

Service

TransactionID

TransactionID

Amount

Amount

UserData

UserData

Status

Status

Sign

Sign

PerfDT

PerfDT


Kolumna PaymentTransactionID tabeli PaymentTransaction

Definicja kolumny PaymentTransactionID tabeli PaymentTransaction

Name

PaymentTransactionID

Code

PaymentTransactionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID transakcji platnosci


Kolumna PaymentServiceID tabeli PaymentTransaction

Definicja kolumny PaymentServiceID tabeli PaymentTransaction

Name

PaymentServiceID

Code

PaymentServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID serwisu platnosci on-line


Kolumna Service tabeli PaymentTransaction

Definicja kolumny Service tabeli PaymentTransaction

Name

Service

Code

Service

Data Type

VARCHAR2(256)

Mandatory

No

Comment

Identyfikator punktu platnosci


Kolumna TransactionID tabeli PaymentTransaction

Definicja kolumny TransactionID tabeli PaymentTransaction

Name

TransactionID

Code

TransactionID

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Identyfikator transakcji w systemie platnosci


Kolumna Amount tabeli PaymentTransaction

Definicja kolumny Amount tabeli PaymentTransaction

Name

Amount

Code

Amount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

Kwota transakcji


Kolumna UserData tabeli PaymentTransaction

Definicja kolumny UserData tabeli PaymentTransaction

Name

UserData

Code

UserData

Data Type

VARCHAR2(258)

Mandatory

No

Comment

Dodatkowe dane przekazane w procesie autoryzacji nowej transakcji


Kolumna Status tabeli PaymentTransaction

Definicja kolumny Status tabeli PaymentTransaction

Name

Status

Code

Status

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Status platnosci


Kolumna Sign tabeli PaymentTransaction

Definicja kolumny Sign tabeli PaymentTransaction

Name

Sign

Code

Sign

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Podpis wysylanych danych


Kolumna PerfDT tabeli PaymentTransaction

Definicja kolumny PerfDT tabeli PaymentTransaction

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

Data przetworzenia transakcji


Lista kluczy tabeli PaymentTransaction

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PaymentTransaction

Definicja klucza Identifier_1 tabeli PaymentTransaction

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment